<?xml version="1.0" ?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.1600.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="1" StatementId="1" StatementOptmLevel="FULL" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" StatementSubTreeCost="0.0179408" StatementText="SELECT *, Queries.CreatorId + Queries.Name FROM Queries&#xD;&#xA;INNER JOIN CachedResults&#xD;&#xA;ON Queries.QueryHash = CachedResults.QueryHash&#xD;&#xA;AND LEN( Queries.Name ) &gt; 10&#xD;&#xA;ORDER BY Queries.FirstRun DESC" StatementType="SELECT" QueryHash="0xC6717A2A01266192" QueryPlanHash="0xF10AE5DD2F033CE5">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan DegreeOfParallelism="0" MemoryGrant="1024" CachedPlanSize="24" CompileTime="3" CompileCPU="3" CompileMemory="192">
            <RelOp AvgRowSize="9223" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="0.0179408">
              <OutputList>
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Id" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryHash" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryBody" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorId" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorIP" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="FirstRun" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Views" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Name" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Description" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="QueryHash" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="SiteId" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="Results" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="CreationDate" />
                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="Id" />
                <ColumnReference Column="Expr1007" />
              </OutputList>
              <RunTimeInformation>
                <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
              </RunTimeInformation>
              <NestedLoops Optimized="false">
                <OuterReferences>
                  <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryHash" />
                </OuterReferences>
                <RelOp AvgRowSize="5177" EstimateCPU="0.000105177" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Sort" NodeId="1" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.0146535">
                  <OutputList>
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Id" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryHash" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryBody" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorId" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorIP" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="FirstRun" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Views" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Name" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Description" />
                    <ColumnReference Column="Expr1007" />
                  </OutputList>
                  <MemoryFractions Input="1" Output="1" />
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRebinds="1" ActualRewinds="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
                  </RunTimeInformation>
                  <Sort Distinct="false">
                    <OrderBy>
                      <OrderByColumn Ascending="false">
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="FirstRun" />
                      </OrderByColumn>
                    </OrderBy>
                    <RelOp AvgRowSize="5181" EstimateCPU="3E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="2" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.0032856">
                      <OutputList>
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Id" />
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryHash" />
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryBody" />
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorId" />
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorIP" />
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="FirstRun" />
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Views" />
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Name" />
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Description" />
                        <ColumnReference Column="Expr1007" />
                      </OutputList>
                      <ComputeScalar>
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Column="Expr1007" />
                            <ScalarOperator ScalarString="[DataExplorer].[dbo].[Queries].[CreatorId]+CONVERT_IMPLICIT(int,[DataExplorer].[dbo].[Queries].[Name],0)">
                              <Arithmetic Operation="ADD">
                                <ScalarOperator>
                                  <Identifier>
                                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorId" />
                                  </Identifier>
                                </ScalarOperator>
                                <ScalarOperator>
                                  <Convert DataType="int" Style="0" Implicit="true">
                                    <ScalarOperator>
                                      <Identifier>
                                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Name" />
                                      </Identifier>
                                    </ScalarOperator>
                                  </Convert>
                                </ScalarOperator>
                              </Arithmetic>
                            </ScalarOperator>
                          </DefinedValue>
                        </DefinedValues>
                        <RelOp AvgRowSize="5173" EstimateCPU="0.0001603" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Scan" NodeId="3" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0032853" TableCardinality="3">
                          <OutputList>
                            <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Id" />
                            <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryHash" />
                            <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryBody" />
                            <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorId" />
                            <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorIP" />
                            <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="FirstRun" />
                            <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Views" />
                            <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Name" />
                            <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Description" />
                          </OutputList>
                          <RunTimeInformation>
                            <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
                          </RunTimeInformation>
                          <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Id" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryHash" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryBody" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorId" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="CreatorIP" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="FirstRun" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Views" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Name" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Description" />
                              </DefinedValue>
                            </DefinedValues>
                            <Object Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Index="[PK__Queries__3214EC0715502E78]" IndexKind="Clustered" />
                            <Predicate>
                              <ScalarOperator ScalarString="len([DataExplorer].[dbo].[Queries].[Name])&gt;(10)">
                                <Compare CompareOp="GT">
                                  <ScalarOperator>
                                    <Intrinsic FunctionName="len">
                                      <ScalarOperator>
                                        <Identifier>
                                          <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="Name" />
                                        </Identifier>
                                      </ScalarOperator>
                                    </Intrinsic>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Const ConstValue="(10)" />
                                  </ScalarOperator>
                                </Compare>
                              </ScalarOperator>
                            </Predicate>
                          </IndexScan>
                        </RelOp>
                      </ComputeScalar>
                    </RelOp>
                  </Sort>
                </RelOp>
                <RelOp AvgRowSize="4055" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="7" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="3">
                  <OutputList>
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="QueryHash" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="SiteId" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="Results" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="CreationDate" />
                    <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="Id" />
                  </OutputList>
                  <RunTimeInformation>
                    <RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
                  </RunTimeInformation>
                  <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                    <DefinedValues>
                      <DefinedValue>
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="QueryHash" />
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="SiteId" />
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="Results" />
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="CreationDate" />
                      </DefinedValue>
                      <DefinedValue>
                        <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="Id" />
                      </DefinedValue>
                    </DefinedValues>
                    <Object Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Index="[idx_results]" IndexKind="Clustered" />
                    <SeekPredicates>
                      <SeekPredicateNew>
                        <SeekKeys>
                          <Prefix ScanType="EQ">
                            <RangeColumns>
                              <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[CachedResults]" Column="QueryHash" />
                            </RangeColumns>
                            <RangeExpressions>
                              <ScalarOperator ScalarString="[DataExplorer].[dbo].[Queries].[QueryHash]">
                                <Identifier>
                                  <ColumnReference Database="[DataExplorer]" Schema="[dbo]" Table="[Queries]" Column="QueryHash" />
                                </Identifier>
                              </ScalarOperator>
                            </RangeExpressions>
                          </Prefix>
                        </SeekKeys>
                      </SeekPredicateNew>
                    </SeekPredicates>
                  </IndexScan>
                </RelOp>
              </NestedLoops>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>